Search Results
Excel Magic Trick 367: Any Number Not Zero = TRUE
Excel Magic Trick 459: Non-Zero numbers = TRUE IF Function logical_test Argument Tricks
Excel Magic Trick 314: Convert TRUE & FALSE to 1 and 0
Excel Video 367 Using Arrays to Exclude Values
Excel Magic Trick 365: Return First Non-Blank (Not An Array Formula)
Excel Magic Trick 364: Return First Non-Blank (Array Formula)
Excel Magic Trick 687: Exclude Values Less Than Zero From Non-Contiguous Ranges - Amazing!
Excel Magic Trick 681: Find Smallest Number That Is Greater Than Zero Array Formula
Excel Magic Trick 392: CHOOSE function Randomly Generate 1, 0 or Blank
Excel Magic Trick 331: EXTRACT Numbers without Leading Zeros
Excel - Show a Plus Sign Before Positive Numbers in Excel - Episode 521
Excel Magic Trick 345: Find 1st Positive number and assign 1 MATCH & COUNTIF functions
